﻿CREATE TABLE [dbo].[impMomSpec](
	[MomSpecID] [int] IDENTITY(1,1) NOT NULL,
	[CUSTNUM] [numeric](10, 0) NULL,
	[ALTNUM] [nvarchar](15) null,
	[LASTNAME] [nvarchar](20) null,
	[FIRSTNAME] [nvarchar](15) null,
	[COMPANY] [nvarchar](40) NULL,
	[ADDRESS1] [nvarchar](40) null,
	[ADDRESS2] [nvarchar](40) NULL,
	[CITY] [nvarchar](20) null,
	[STATE] [nvarchar](3) null,
	[ZIPCODE] [nvarchar](10) null,
	[FOREIGN] [nvarchar](1) null,
	[PHONE] [nvarchar](14) null,
	[COMMENT] [nvarchar](40) NULL,
	[CTYPE1] [nvarchar](1) NULL,
	[CTYPE2] [nvarchar](2) NULL,
	[CTYPE3] [nvarchar](4) NULL,
	[TAXEXEMPT] [nvarchar](1) NULL,
	[PROSPECT] [nvarchar](1) NULL,
	[CARDTYPE] [nvarchar](2) NULL,
	[CARDNUM] [nvarchar](19) NULL,
	[EXPIRES] [nvarchar](5) NULL,
	[SOURCE_KEY] [nvarchar](9) NULL,
	[CATALOG] [nvarchar](6) NULL,
	[SALES_ID] [nvarchar](3) NULL,
	[OPER_ID] [nvarchar](3) NULL,
	[REFERENCE] [nvarchar](10) NULL,
	[SHIPVIA] [nvarchar](3) NULL,
	[FULFILLED] [char](1) NULL,
	[PAID] [money] null,
	[CONTINUED] [char](1) NULL,
	[ORDER_DATE] [smalldatetime] null,
	[ORD_NUM] [int] null,
	[PRODUCT01] [nvarchar](20) null,
	[QUANTITY01] [int] null,
	[PRODUCT02] [nvarchar](20) NULL,
	[QUANTITY02] [int] NULL,
	[PRODUCT03] [nvarchar](20) NULL,
	[QUANTITY03] [int] NULL,
	[PRODUCT04] [nvarchar](20) NULL,
	[QUANTITY04] [int] NULL,
	[PRODUCT05] [nvarchar](20) NULL,
	[QUANTITY05] [int] NULL,
	[SLASTNAME] [nvarchar](20) null,
	[SFIRSTNAME] [nvarchar](15) null,
	[SCOMPANY] [nvarchar](40) NULL,
	[SADDRESS1] [nvarchar](40) null,
	[SADDRESS2] [nvarchar](40) NULL,
	[SCITY] [nvarchar](20) null,
	[SSTATE] [nvarchar](3) null,
	[SZIP] [nvarchar](10) null,
	[HOLDDATE] [smalldatetime] NULL,
	[PAYMETHOD] [nvarchar](2) NULL,
	[GREETING1] [nvarchar](35) NULL,
	[GREETING2] [nvarchar](35) NULL,
	[PROMOCRED] [money] NULL,
	[USEPRICES] [nvarchar](1) NULL,
	[PRICE01] [money] null,
	[DISCOUNT01] [float] NULL,
	[PRICE02] [money] NULL,
	[DISCOUNT02] [float] NULL,
	[PRICE03] [money] NULL,
	[DISCOUNT03] [float] NULL,
	[PRICE04] [money] NULL,
	[DISCOUNT04] [float] NULL,
	[PRICE05] [money] NULL,
	[DISCOUNT05] [float] NULL,
	[USESHIPAMT] [char](1) NULL,
	[SHIPPING] [money] NULL,
	[EMAIL] [nvarchar](50) null,
	[COUNTRY] [nvarchar](3) null,
	[SCOUNTRY] [nvarchar](3) null,
	[PHONE2] [nvarchar](14) NULL,
	[SPHONE] [nvarchar](14) NULL,
	[SPHONE2] [nvarchar](14) NULL,
	[SEMAIL] [nvarchar](50) NULL,
	[ORDERTYPE] [nvarchar](6) NULL,
	[INPART] char(1) null,
	[TITLE] nvarchar(40) null,
	[SALU] nvarchar(6) null,
	[HONO] nvarchar(6) null,
	[EXT] nvarchar(5) null,
	[EXT2] nvarchar(5) null,
	[STITLE] nvarchar(6) null,
	[SSALU] nvarchar(6) null,
	[SHONO] nvarchar(6) null,
	[SEXT] nvarchar(5) null,
	[SEXT2] nvarchar(5) null,
	[SHIP_WHEN] smalldatetime null,
	[GREETING3] nvarchar(35) null,
	[GREETING4] nvarchar(35) null,
	[GREETING5] nvarchar(35) null,
	[GREETING6] nvarchar(35) null,
	[PASSWORD] nvarchar(20) null,
	[CUSTOM01] nvarchar(240) null,
	[CUSTOM02] nvarchar(240) null,
	[CUSTOM03] nvarchar(240) null,
	[CUSTOM04] nvarchar(240) null,
	[CUSTOM05] nvarchar(240) null,
	[CARDHOLDER] [nvarchar](30) NULL,
	[ROUTINGNUM] [nvarchar](10) NULL,
	[ACCOUNTNUM] [nvarchar](20) NULL,
	[ACCTTYPE] [nvarchar](10) NULL,
	[BANKNAME] [nvarchar](30) NULL,
	[RCODE] [nvarchar](3) NULL,
	[APPROVAL] [nvarchar](10) NULL,
	[AVS] [nvarchar](2) NULL,
	[ANTRANS_ID] [nvarchar](30) NULL,
	[AUTH_AMT] [money] NULL,
	[AUTH_TIME] smalldatetime NULL,
	[INTERNETID] nvarchar(32) null,
	[ORDNOTE1] nvarchar(240) null,
	[ORDNOTE2] nvarchar(240) null,
	[ORDNOTE3] nvarchar(240) null,
	[ORDNOTE4] nvarchar(240) null,
	[ORDNOTE5] nvarchar(240) null,
	[FULFILL1] nvarchar(240) null,
	[FULFILL2] nvarchar(240) null,
	[FULFILL3] nvarchar(240) null,
	[FULFILL4] nvarchar(240) null,
	[FULFILL5] nvarchar(240) null,
	[INTERNET] char(1) null,
	[PRIORITY] CHAR(1) null,
	[NOMAIL] char(1) null,
	[NORENT] char(1) null,
	[NOEMAIL] char(1) null,
	[PONUMBER] nvarchar(15) null,
	[ADDRESS3] nvarchar(30) null,
	[SADDRESS3] nvarchar(30) null,
	[CC_OTHER] nvarchar(4) null,
	[PROMO_CODE] nvarchar(10) null,
	[BEST_PROMO] char(1) null,
	[ORDERMEMO1] nvarchar(70) null,
	[ORDERMEMO2] nvarchar(70) null,
	[ORDERMEMO3] nvarchar(70) null,
	[MULTISHIP] char(1) null,
	[ISSUE_NUM] nvarchar(2) null,
	[FRDATE] nvarchar(5) null,
	[R_CODE01] char(1) null,
	[R_CODE02] char(1) null,
	[R_CODE03] char(1) null,
	[R_CODE04] char(1) null,
	[R_CODE05] char(1) null,
	[ALTIT_ID01] nvarchar(20) null,
	[ALTIT_ID02] nvarchar(20) null,
	[ALTIT_ID03] nvarchar(20) null,
	[ALTIT_ID04] nvarchar(20) null,
	[ALTIT_ID05] nvarchar(20) null
) 
